{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "ename": "",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31mFailed to start the Kernel. \n",
      "\u001b[1;31mTraceback (most recent call last):\n",
      "\u001b[1;31m  File \"/root/.vscode-server/extensions/ms-toolsai.jupyter-2022.9.1303220346/pythonFiles/vscode_datascience_helpers/daemon/daemon_python.py\", line 54, in _decorator\n",
      "\u001b[1;31m    return func(self, *args, **kwargs)\n",
      "\u001b[1;31m  File \"/root/.vscode-server/extensions/ms-toolsai.jupyter-2022.9.1303220346/pythonFiles/vscode_datascience_helpers/jupyter_daemon.py\", line 111, in m_exec_module_observable\n",
      "\u001b[1;31m    self._start_notebook(args, cwd, env)\n",
      "\u001b[1;31m  File \"/root/.vscode-server/extensions/ms-toolsai.jupyter-2022.9.1303220346/pythonFiles/vscode_datascience_helpers/jupyter_daemon.py\", line 168, in _start_notebook\n",
      "\u001b[1;31m    app.launch_new_instance()\n",
      "\u001b[1;31m  File \"/root/anaconda3/lib/python3.9/site-packages/jupyter_core/application.py\", line 264, in launch_instance\n",
      "\u001b[1;31m    return super(JupyterApp, cls).launch_instance(argv=argv, **kwargs)\n",
      "\u001b[1;31m  File \"/root/anaconda3/lib/python3.9/site-packages/traitlets/config/application.py\", line 846, in launch_instance\n",
      "\u001b[1;31m    app.start()\n",
      "\u001b[1;31m  File \"/root/anaconda3/lib/python3.9/site-packages/notebook/notebookapp.py\", line 2292, in start\n",
      "\u001b[1;31m    self.exit(1)\n",
      "\u001b[1;31m  File \"/root/anaconda3/lib/python3.9/site-packages/traitlets/config/application.py\", line 836, in exit\n",
      "\u001b[1;31m    sys.exit(exit_status)\n",
      "\u001b[1;31mSystemExit: 1\n",
      "\u001b[1;31m\n",
      "\u001b[1;31m[W 2022-12-07 22:14:23.101 LabApp] 'notebook_dir' has moved from NotebookApp to ServerApp. This config will be passed to ServerApp. Be sure to update your config before our next release.\n",
      "\u001b[1;31m\n",
      "\u001b[1;31m[W 2022-12-07 22:14:23.102 LabApp] 'config_file' was found in both NotebookApp and ServerApp. This is likely a recent change. This config will only be set in NotebookApp. Please check if you should also config these traits in ServerApp for your purpose.\n",
      "\u001b[1;31m\n",
      "\u001b[1;31m[W 2022-12-07 22:14:23.102 LabApp] 'iopub_data_rate_limit' has moved from NotebookApp to ServerApp. This config will be passed to ServerApp. Be sure to update your config before our next release.\n",
      "\u001b[1;31m\n",
      "\u001b[1;31m[W 2022-12-07 22:14:23.102 LabApp] 'iopub_data_rate_limit' has moved from NotebookApp to ServerApp. This config will be passed to ServerApp. Be sure to update your config before our next release.\n",
      "\u001b[1;31m\n",
      "\u001b[1;31m[I 2022-12-07 22:14:23.130 LabApp] JupyterLab extension loaded from /root/anaconda3/lib/python3.9/site-packages/jupyterlab\n",
      "\u001b[1;31m\n",
      "\u001b[1;31m[I 2022-12-07 22:14:23.130 LabApp] JupyterLab application directory is /root/anaconda3/share/jupyter/lab\n",
      "\u001b[1;31m\n",
      "\u001b[1;31m[C 22:14:23.132 NotebookApp] Running as root is not recommended. Use --allow-root to bypass.\n",
      "\u001b[1;31m\n",
      "\u001b[1;31mFailed to run jupyter as observable with args notebook --no-browser --notebook-dir=\"/mnt/zh/decide-tree-regression\" --config=/tmp/bb196c3c-314e-421d-be0e-a8bb94d40542/jupyter_notebook_config.py --NotebookApp.iopub_data_rate_limit=10000000000.0. \n",
      "\u001b[1;31mView Jupyter <a href='command:jupyter.viewOutput'>log</a> for further details."
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "f = pd.ExcelFile('data2/CSV20201227-28.xlsx')\n",
    "f.sheet_names  # 获取工作表名称\n",
    " \n",
    "df = pd.DataFrame()\n",
    "for i in f.sheet_names:\n",
    "    d = pd.read_excel('data2/CSV20201227-28.xlsx', sheetname=i)\n",
    "    df = pd.concat([df, d], axis=0)\n",
    "df.shape\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "name": "python",
   "version": "3.9.12 (main, Apr  5 2022, 06:56:58) \n[GCC 7.5.0]"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "dac8846c56bd8bb5c60b43f4d737a9f5aeedac8149ef0c6c701a72a56285111f"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
